Dataset statistics
| Number of variables | 64 |
|---|---|
| Number of observations | 9987 |
| Missing cells | 51199 |
| Missing cells (%) | 8.0% |
| Duplicate rows | 288 |
| Duplicate rows (%) | 2.9% |
| Total size in memory | 4.9 MiB |
| Average record size in memory | 512.0 B |
Variable types
| NUM | 33 |
|---|---|
| BOOL | 21 |
| CAT | 10 |
| Dataset has 288 (2.9%) duplicate rows | Duplicates |
GP4 has a high cardinality: 1296 distinct values | High cardinality |
HUMAN_V1 is highly correlated with HUMAN_T1 | High correlation |
HUMAN_T1 is highly correlated with HUMAN_V1 | High correlation |
JUL_START_DATE is highly correlated with year and 2 other fields | High correlation |
year is highly correlated with JUL_START_DATE and 2 other fields | High correlation |
JUL_END_DATE is highly correlated with year and 2 other fields | High correlation |
PUB_YEAR is highly correlated with year and 2 other fields | High correlation |
event is highly correlated with recap and 1 other fields | High correlation |
recap is highly correlated with event and 1 other fields | High correlation |
STAT_ACT is highly correlated with EXP_TYPE and 1 other fields | High correlation |
EXP_TYPE is highly correlated with STAT_ACT | High correlation |
ATK_TYPE is highly correlated with STAT_ACT | High correlation |
N_OF_INI_A is highly correlated with N_OF_INI_P | High correlation |
N_OF_INI_P is highly correlated with N_OF_INI_A | High correlation |
QUASI_EVENT is highly correlated with recap and 1 other fields | High correlation |
INI_TYPE has 721 (7.2%) missing values | Missing |
NGOV_I1 has 2223 (22.3%) missing values | Missing |
TAR_TYPE has 318 (3.2%) missing values | Missing |
HUMAN_T1 has 3013 (30.2%) missing values | Missing |
HUMAN_V1 has 2951 (29.5%) missing values | Missing |
EV_TYPE has 131 (1.3%) missing values | Missing |
pinpoint has 308 (3.1%) missing values | Missing |
GP7 has 112 (1.1%) missing values | Missing |
GP8 has 111 (1.1%) missing values | Missing |
AD_TACT has 4690 (47.0%) missing values | Missing |
EXP_TYPE has 4705 (47.1%) missing values | Missing |
ATK_TYPE has 6525 (65.3%) missing values | Missing |
DSA_TYPE has 8619 (86.3%) missing values | Missing |
STAT_ACT has 8631 (86.4%) missing values | Missing |
N_OF_INI_P has 3544 (35.5%) missing values | Missing |
N_OF_INI_A has 1169 (11.7%) missing values | Missing |
victim_effect has 3151 (31.6%) missing values | Missing |
N_INJURD is highly skewed (γ1 = 25.0150656) | Skewed |
N_KILLED_P is highly skewed (γ1 = 39.44361892) | Skewed |
N_KILLED_A is highly skewed (γ1 = 38.64096993) | Skewed |
TAR_TYPE has 978 (9.8%) zeros | Zeros |
N_INJURD has 9245 (92.6%) zeros | Zeros |
N_KILLED_P has 8903 (89.1%) zeros | Zeros |
N_KILLED_A has 8903 (89.1%) zeros | Zeros |
N_INJURD_D has 9245 (92.6%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-25 19:48:50.776659 |
|---|---|
| Analysis finished | 2020-10-25 19:51:28.911025 |
| Duration | 2 minutes and 38.13 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
month
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.593587174 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.085571671 |
|---|---|
| Coefficient of variation (CV) | 0.4679655534 |
| Kurtosis | -0.9250476375 |
| Mean | 6.593587174 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.0870067551 |
| Sum | 65804 |
| Variance | 9.520752538 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 7 | 1635 | 16.4% | |
| 9 | 990 | 9.9% | |
| 5 | 930 | 9.3% | |
| 8 | 924 | 9.3% | |
| 4 | 884 | 8.9% | |
| 10 | 771 | 7.7% | |
| 3 | 718 | 7.2% | |
| 6 | 706 | 7.1% | |
| 11 | 685 | 6.9% | |
| 2 | 603 | 6.0% | |
| Other values (2) | 1134 | 11.4% |
| Value | Count | Frequency (%) | |
| 1 | 598 | 6.0% | |
| 2 | 603 | 6.0% | |
| 3 | 718 | 7.2% | |
| 4 | 884 | 8.9% | |
| 5 | 930 | 9.3% |
| Value | Count | Frequency (%) | |
| 12 | 536 | 5.4% | |
| 11 | 685 | 6.9% | |
| 10 | 771 | 7.7% | |
| 9 | 990 | 9.9% | |
| 8 | 924 | 9.3% |
| Distinct | 60 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1972.979674 |
|---|---|
| Minimum | 1946 |
| Maximum | 2005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1946 |
|---|---|
| 5-th percentile | 1949 |
| Q1 | 1964 |
| median | 1970 |
| Q3 | 1983 |
| 95-th percentile | 2001 |
| Maximum | 2005 |
| Range | 59 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 14.38978038 |
|---|---|
| Coefficient of variation (CV) | 0.007293425561 |
| Kurtosis | -0.5474435489 |
| Mean | 1972.979674 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.3314007758 |
| Sum | 19704148 |
| Variance | 207.0657795 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) | |
| 1969 | 530 | 5.3% | |
| 1970 | 491 | 4.9% | |
| 1963 | 465 | 4.7% | |
| 1968 | 433 | 4.3% | |
| 1966 | 359 | 3.6% | |
| 1965 | 355 | 3.6% | |
| 1967 | 355 | 3.6% | |
| 1971 | 336 | 3.4% | |
| 1964 | 312 | 3.1% | |
| 1979 | 282 | 2.8% | |
| Other values (50) | 6069 | 60.8% |
| Value | Count | Frequency (%) | |
| 1946 | 157 | 1.6% | |
| 1947 | 100 | 1.0% | |
| 1948 | 142 | 1.4% | |
| 1949 | 129 | 1.3% | |
| 1950 | 118 | 1.2% |
| Value | Count | Frequency (%) | |
| 2005 | 32 | 0.3% | |
| 2004 | 38 | 0.4% | |
| 2003 | 95 | 1.0% | |
| 2002 | 77 | 0.8% | |
| 2001 | 266 | 2.7% |
KNOW_INI
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 62 |
| Missing (%) | 0.6% |
| Memory size | 78.0 KiB |
| 1 | |
|---|---|
| 0 | 584 |
| 0.5 | 369 |
| 2 | 137 |
| Value | Count | Frequency (%) | |
| 1 | 8835 | 88.5% | |
| 0 | 584 | 5.8% | |
| 0.5 | 369 | 3.7% | |
| 2 | 137 | 1.4% | |
| (Missing) | 62 | 0.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 721 |
| Missing (%) | 7.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.184113965 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4559259717 |
|---|---|
| Coefficient of variation (CV) | 0.38503555 |
| Kurtosis | 19.27644752 |
| Mean | 1.184113965 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.515762296 |
| Sum | 10972 |
| Variance | 0.2078684917 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 7708 | 77.2% | |
| 2 | 1498 | 15.0% | |
| 5 | 31 | 0.3% | |
| 4 | 26 | 0.3% | |
| 3 | 3 | < 0.1% | |
| (Missing) | 721 | 7.2% |
| Value | Count | Frequency (%) | |
| 1 | 7708 | 77.2% | |
| 2 | 1498 | 15.0% | |
| 3 | 3 | < 0.1% | |
| 4 | 26 | 0.3% | |
| 5 | 31 | 0.3% |
| Value | Count | Frequency (%) | |
| 5 | 31 | 0.3% | |
| 4 | 26 | 0.3% | |
| 3 | 3 | < 0.1% | |
| 2 | 1498 | 15.0% | |
| 1 | 7708 | 77.2% |
| Distinct | 38 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 2223 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.9359866 |
|---|---|
| Minimum | 1 |
| Maximum | 41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 10 |
| Q3 | 25 |
| 95-th percentile | 39 |
| Maximum | 41 |
| Range | 40 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 13.07072678 |
|---|---|
| Coefficient of variation (CV) | 0.8751163971 |
| Kurtosis | -1.110478242 |
| Mean | 14.9359866 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.5980628194 |
| Sum | 115963 |
| Variance | 170.8438987 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 1141 | 11.4% | |
| 5 | 951 | 9.5% | |
| 6 | 819 | 8.2% | |
| 15 | 721 | 7.2% | |
| 32 | 556 | 5.6% | |
| 39 | 502 | 5.0% | |
| 2 | 459 | 4.6% | |
| 3 | 296 | 3.0% | |
| 25 | 269 | 2.7% | |
| 24 | 267 | 2.7% | |
| Other values (28) | 1783 | 17.9% | |
| (Missing) | 2223 | 22.3% |
| Value | Count | Frequency (%) | |
| 1 | 1141 | 11.4% | |
| 2 | 459 | 4.6% | |
| 3 | 296 | 3.0% | |
| 4 | 9 | 0.1% | |
| 5 | 951 | 9.5% |
| Value | Count | Frequency (%) | |
| 41 | 4 | < 0.1% | |
| 39 | 502 | 5.0% | |
| 38 | 121 | 1.2% | |
| 37 | 184 | 1.8% | |
| 36 | 29 | 0.3% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 318 |
| Missing (%) | 3.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.274071776 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 978 |
| Zeros (%) | 9.8% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8754518778 |
|---|---|
| Coefficient of variation (CV) | 0.6871291668 |
| Kurtosis | 2.58826062 |
| Mean | 1.274071776 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.493263981 |
| Sum | 12319 |
| Variance | 0.7664159903 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 6372 | 63.8% | |
| 2 | 1466 | 14.7% | |
| 0 | 978 | 9.8% | |
| 4 | 456 | 4.6% | |
| 3 | 397 | 4.0% | |
| (Missing) | 318 | 3.2% |
| Value | Count | Frequency (%) | |
| 0 | 978 | 9.8% | |
| 1 | 6372 | 63.8% | |
| 2 | 1466 | 14.7% | |
| 3 | 397 | 4.0% | |
| 4 | 456 | 4.6% |
| Value | Count | Frequency (%) | |
| 4 | 456 | 4.6% | |
| 3 | 397 | 4.0% | |
| 2 | 1466 | 14.7% | |
| 1 | 6372 | 63.8% | |
| 0 | 978 | 9.8% |
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 3013 |
| Missing (%) | 30.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.9455119 |
|---|---|
| Minimum | 1 |
| Maximum | 41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 36 |
| Q3 | 37 |
| 95-th percentile | 38 |
| Maximum | 41 |
| Range | 40 |
| Interquartile range (IQR) | 32 |
Descriptive statistics
| Standard deviation | 15.06916648 |
|---|---|
| Coefficient of variation (CV) | 0.6040832731 |
| Kurtosis | -1.428956412 |
| Mean | 24.9455119 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.6153122204 |
| Sum | 173970 |
| Variance | 227.0797784 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 37 | 2886 | 28.9% | |
| 1 | 833 | 8.3% | |
| 36 | 621 | 6.2% | |
| 5 | 590 | 5.9% | |
| 39 | 230 | 2.3% | |
| 2 | 198 | 2.0% | |
| 16 | 198 | 2.0% | |
| 15 | 155 | 1.6% | |
| 38 | 127 | 1.3% | |
| 6 | 121 | 1.2% | |
| Other values (30) | 1015 | 10.2% | |
| (Missing) | 3013 | 30.2% |
| Value | Count | Frequency (%) | |
| 1 | 833 | 8.3% | |
| 2 | 198 | 2.0% | |
| 3 | 87 | 0.9% | |
| 4 | 41 | 0.4% | |
| 5 | 590 | 5.9% |
| Value | Count | Frequency (%) | |
| 41 | 10 | 0.1% | |
| 40 | 1 | < 0.1% | |
| 39 | 230 | 2.3% | |
| 38 | 127 | 1.3% | |
| 37 | 2886 | 28.9% |
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 2951 |
| Missing (%) | 29.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.70650938 |
|---|---|
| Minimum | 1 |
| Maximum | 41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 36 |
| Q3 | 37 |
| 95-th percentile | 38 |
| Maximum | 41 |
| Range | 40 |
| Interquartile range (IQR) | 32 |
Descriptive statistics
| Standard deviation | 15.1199936 |
|---|---|
| Coefficient of variation (CV) | 0.6119842089 |
| Kurtosis | -1.477322958 |
| Mean | 24.70650938 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.5773758174 |
| Sum | 173835 |
| Variance | 228.6142064 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 37 | 2848 | 28.5% | |
| 1 | 831 | 8.3% | |
| 5 | 660 | 6.6% | |
| 36 | 618 | 6.2% | |
| 39 | 248 | 2.5% | |
| 16 | 192 | 1.9% | |
| 2 | 187 | 1.9% | |
| 15 | 166 | 1.7% | |
| 6 | 132 | 1.3% | |
| 38 | 130 | 1.3% | |
| Other values (30) | 1024 | 10.3% | |
| (Missing) | 2951 | 29.5% |
| Value | Count | Frequency (%) | |
| 1 | 831 | 8.3% | |
| 2 | 187 | 1.9% | |
| 3 | 85 | 0.9% | |
| 4 | 41 | 0.4% | |
| 5 | 660 | 6.6% |
| Value | Count | Frequency (%) | |
| 41 | 10 | 0.1% | |
| 40 | 1 | < 0.1% | |
| 39 | 248 | 2.5% | |
| 38 | 130 | 1.3% | |
| 37 | 2848 | 28.5% |
DATE_TYP
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Memory size | 78.0 KiB |
| 1 | |
|---|---|
| 3 | |
| 4 | |
| 2 | 622 |
| Value | Count | Frequency (%) | |
| 1 | 6289 | 63.0% | |
| 3 | 1793 | 18.0% | |
| 4 | 1276 | 12.8% | |
| 2 | 622 | 6.2% | |
| (Missing) | 7 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
day
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.29318637 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 9 |
| median | 16 |
| Q3 | 21 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.870788221 |
|---|---|
| Coefficient of variation (CV) | 0.5146597987 |
| Kurtosis | -0.8241362319 |
| Mean | 15.29318637 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.0710549614 |
| Sum | 152626 |
| Variance | 61.94930721 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 16 | 1577 | 15.8% | |
| 11 | 462 | 4.6% | |
| 15 | 430 | 4.3% | |
| 4 | 332 | 3.3% | |
| 12 | 315 | 3.2% | |
| 23 | 307 | 3.1% | |
| 18 | 301 | 3.0% | |
| 13 | 301 | 3.0% | |
| 10 | 298 | 3.0% | |
| 5 | 296 | 3.0% | |
| Other values (21) | 5361 | 53.7% |
| Value | Count | Frequency (%) | |
| 1 | 247 | 2.5% | |
| 2 | 244 | 2.4% | |
| 3 | 280 | 2.8% | |
| 4 | 332 | 3.3% | |
| 5 | 296 | 3.0% |
| Value | Count | Frequency (%) | |
| 31 | 113 | 1.1% | |
| 30 | 194 | 1.9% | |
| 29 | 263 | 2.6% | |
| 28 | 231 | 2.3% | |
| 27 | 248 | 2.5% |
| Distinct | 4471 |
|---|---|
| Distinct (%) | 44.8% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10381.66463 |
|---|---|
| Minimum | 326 |
| Maximum | 22270 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 326 |
|---|---|
| 5-th percentile | 1726.55 |
| Q1 | 6956.75 |
| median | 9249 |
| Q3 | 14028.75 |
| 95-th percentile | 20546 |
| Maximum | 22270 |
| Range | 21944 |
| Interquartile range (IQR) | 7072 |
Descriptive statistics
| Standard deviation | 5249.946409 |
|---|---|
| Coefficient of variation (CV) | 0.5056940863 |
| Kurtosis | -0.5393730754 |
| Mean | 10381.66463 |
| Median Absolute Deviation (MAD) | 3321 |
| Skewness | 0.3337494114 |
| Sum | 103609013 |
| Variance | 27561937.29 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 20709 | 163 | 1.6% | |
| 17533 | 57 | 0.6% | |
| 18263 | 31 | 0.3% | |
| 6575 | 31 | 0.3% | |
| 9497 | 30 | 0.3% | |
| 14245 | 29 | 0.3% | |
| 12784 | 27 | 0.3% | |
| 7306 | 27 | 0.3% | |
| 9255 | 27 | 0.3% | |
| 9132 | 26 | 0.3% | |
| Other values (4461) | 9532 | 95.4% |
| Value | Count | Frequency (%) | |
| 326 | 1 | < 0.1% | |
| 366 | 8 | 0.1% | |
| 368 | 1 | < 0.1% | |
| 369 | 1 | < 0.1% | |
| 371 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 22270 | 1 | < 0.1% | |
| 22242 | 1 | < 0.1% | |
| 22163 | 4 | < 0.1% | |
| 22138 | 1 | < 0.1% | |
| 22129 | 3 | < 0.1% |
| Distinct | 4595 |
|---|---|
| Distinct (%) | 46.0% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10451.93627 |
|---|---|
| Minimum | 378 |
| Maximum | 22270 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 378 |
|---|---|
| 5-th percentile | 1758 |
| Q1 | 7032 |
| median | 9259 |
| Q3 | 14137.5 |
| 95-th percentile | 20576 |
| Maximum | 22270 |
| Range | 21892 |
| Interquartile range (IQR) | 7105.5 |
Descriptive statistics
| Standard deviation | 5270.646587 |
|---|---|
| Coefficient of variation (CV) | 0.5042746578 |
| Kurtosis | -0.5583132705 |
| Mean | 10451.93627 |
| Median Absolute Deviation (MAD) | 3338 |
| Skewness | 0.3311391991 |
| Sum | 104310324 |
| Variance | 27779715.44 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 20709 | 149 | 1.5% | |
| 17898 | 51 | 0.5% | |
| 9132 | 31 | 0.3% | |
| 9255 | 30 | 0.3% | |
| 18627 | 27 | 0.3% | |
| 9861 | 27 | 0.3% | |
| 6939 | 25 | 0.3% | |
| 7671 | 25 | 0.3% | |
| 18371 | 25 | 0.3% | |
| 14609 | 22 | 0.2% | |
| Other values (4585) | 9568 | 95.8% |
| Value | Count | Frequency (%) | |
| 378 | 1 | < 0.1% | |
| 379 | 2 | < 0.1% | |
| 382 | 1 | < 0.1% | |
| 383 | 1 | < 0.1% | |
| 385 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 22270 | 1 | < 0.1% | |
| 22242 | 1 | < 0.1% | |
| 22171 | 1 | < 0.1% | |
| 22163 | 4 | < 0.1% | |
| 22159 | 2 | < 0.1% |
DAY_SPAN
Real number (ℝ≥0)
| Distinct | 373 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.27164329 |
|---|---|
| Minimum | 1 |
| Maximum | 11049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 12 |
| 95-th percentile | 365 |
| Maximum | 11049 |
| Range | 11048 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 377.7753416 |
|---|---|
| Coefficient of variation (CV) | 5.300499948 |
| Kurtosis | 302.647245 |
| Mean | 71.27164329 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.17705829 |
| Sum | 711291 |
| Variance | 142714.2087 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 6329 | 63.4% | |
| 31 | 467 | 4.7% | |
| 365 | 423 | 4.2% | |
| 2 | 220 | 2.2% | |
| 7 | 186 | 1.9% | |
| 366 | 164 | 1.6% | |
| 3 | 143 | 1.4% | |
| 4 | 127 | 1.3% | |
| 8 | 111 | 1.1% | |
| 6 | 104 | 1.0% | |
| Other values (363) | 1706 | 17.1% |
| Value | Count | Frequency (%) | |
| 1 | 6329 | 63.4% | |
| 2 | 220 | 2.2% | |
| 3 | 143 | 1.4% | |
| 4 | 127 | 1.3% | |
| 5 | 103 | 1.0% |
| Value | Count | Frequency (%) | |
| 11049 | 1 | < 0.1% | |
| 9835 | 2 | < 0.1% | |
| 7669 | 1 | < 0.1% | |
| 7305 | 3 | < 0.1% | |
| 7142 | 1 | < 0.1% |
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.651947532 |
|---|---|
| Minimum | 0 |
| Maximum | 3000 |
| Zeros | 9245 |
| Zeros (%) | 92.6% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 3000 |
| Range | 3000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 66.68013012 |
|---|---|
| Coefficient of variation (CV) | 14.33380958 |
| Kurtosis | 784.9044073 |
| Mean | 4.651947532 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.0150656 |
| Sum | 46459 |
| Variance | 4446.239753 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 9245 | 92.6% | |
| 1 | 217 | 2.2% | |
| 2 | 78 | 0.8% | |
| 3 | 78 | 0.8% | |
| 4 | 36 | 0.4% | |
| 12 | 34 | 0.3% | |
| 5 | 34 | 0.3% | |
| 300 | 24 | 0.2% | |
| 9 | 21 | 0.2% | |
| 50 | 19 | 0.2% | |
| Other values (80) | 201 | 2.0% |
| Value | Count | Frequency (%) | |
| 0 | 9245 | 92.6% | |
| 1 | 217 | 2.2% | |
| 2 | 78 | 0.8% | |
| 3 | 78 | 0.8% | |
| 4 | 36 | 0.4% |
| Value | Count | Frequency (%) | |
| 3000 | 1 | < 0.1% | |
| 2000 | 3 | < 0.1% | |
| 1501 | 1 | < 0.1% | |
| 1500 | 2 | < 0.1% | |
| 1202 | 1 | < 0.1% |
TAR_GPOL
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 414 |
| Value | Count | Frequency (%) | |
| 0 | 9573 | 95.9% | |
| 1 | 414 | 4.1% |
aid
Real number (ℝ≥0)
| Distinct | 5085 |
|---|---|
| Distinct (%) | 50.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19850991.54 |
|---|---|
| Minimum | 1741189 |
| Maximum | 52980956 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1741189 |
|---|---|
| 5-th percentile | 2380094 |
| Q1 | 20744912 |
| median | 21552675 |
| Q3 | 22574485 |
| 95-th percentile | 24038606.75 |
| Maximum | 52980956 |
| Range | 51239767 |
| Interquartile range (IQR) | 1829573 |
Descriptive statistics
| Standard deviation | 6642845.409 |
|---|---|
| Coefficient of variation (CV) | 0.3346354461 |
| Kurtosis | 4.643122713 |
| Mean | 19850991.54 |
| Median Absolute Deviation (MAD) | 925711 |
| Skewness | -1.497261962 |
| Sum | 1.982320015e+11 |
| Variance | 4.412739513e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 22754066 | 21 | 0.2% | |
| 22146005 | 20 | 0.2% | |
| 20871541 | 19 | 0.2% | |
| 21711421 | 18 | 0.2% | |
| 20740699 | 18 | 0.2% | |
| 21086783 | 17 | 0.2% | |
| 21484113 | 17 | 0.2% | |
| 22295390 | 17 | 0.2% | |
| 20149636 | 16 | 0.2% | |
| 22539198 | 16 | 0.2% | |
| Other values (5075) | 9807 | 98.2% |
| Value | Count | Frequency (%) | |
| 1741189 | 1 | < 0.1% | |
| 1743550 | 3 | < 0.1% | |
| 1745006 | 2 | < 0.1% | |
| 1748657 | 1 | < 0.1% | |
| 1749747 | 7 | 0.1% |
| Value | Count | Frequency (%) | |
| 52980956 | 1 | < 0.1% | |
| 52592027 | 1 | < 0.1% | |
| 52219708 | 3 | < 0.1% | |
| 52199873 | 1 | < 0.1% | |
| 52140731 | 1 | < 0.1% |
PUB_MON
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.598478021 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.309913507 |
|---|---|
| Coefficient of variation (CV) | 0.501617721 |
| Kurtosis | -1.133995364 |
| Mean | 6.598478021 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.05253507696 |
| Sum | 65899 |
| Variance | 10.95552742 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 8 | 967 | 9.7% | |
| 7 | 944 | 9.5% | |
| 9 | 934 | 9.4% | |
| 5 | 920 | 9.2% | |
| 4 | 879 | 8.8% | |
| 10 | 866 | 8.7% | |
| 11 | 804 | 8.1% | |
| 3 | 804 | 8.1% | |
| 6 | 760 | 7.6% | |
| 12 | 704 | 7.0% | |
| Other values (2) | 1405 | 14.1% |
| Value | Count | Frequency (%) | |
| 1 | 701 | 7.0% | |
| 2 | 704 | 7.0% | |
| 3 | 804 | 8.1% | |
| 4 | 879 | 8.8% | |
| 5 | 920 | 9.2% |
| Value | Count | Frequency (%) | |
| 12 | 704 | 7.0% | |
| 11 | 804 | 8.1% | |
| 10 | 866 | 8.7% | |
| 9 | 934 | 9.4% | |
| 8 | 967 | 9.7% |
PUB_DATE
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.85671373 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 24 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 8.779573396 |
|---|---|
| Coefficient of variation (CV) | 0.5536817746 |
| Kurtosis | -1.191928208 |
| Mean | 15.85671373 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.01268790223 |
| Sum | 158361 |
| Variance | 77.08090901 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 24 | 389 | 3.9% | |
| 13 | 374 | 3.7% | |
| 17 | 369 | 3.7% | |
| 30 | 357 | 3.6% | |
| 19 | 356 | 3.6% | |
| 11 | 343 | 3.4% | |
| 28 | 341 | 3.4% | |
| 12 | 339 | 3.4% | |
| 27 | 334 | 3.3% | |
| 6 | 333 | 3.3% | |
| Other values (21) | 6452 | 64.6% |
| Value | Count | Frequency (%) | |
| 1 | 314 | 3.1% | |
| 2 | 308 | 3.1% | |
| 3 | 333 | 3.3% | |
| 4 | 329 | 3.3% | |
| 5 | 333 | 3.3% |
| Value | Count | Frequency (%) | |
| 31 | 153 | 1.5% | |
| 30 | 357 | 3.6% | |
| 29 | 301 | 3.0% | |
| 28 | 341 | 3.4% | |
| 27 | 334 | 3.3% |
| Distinct | 61 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1973.823671 |
|---|---|
| Minimum | 1946 |
| Maximum | 2006 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1946 |
|---|---|
| 5-th percentile | 1950 |
| Q1 | 1964 |
| median | 1970 |
| Q3 | 1984 |
| 95-th percentile | 2001 |
| Maximum | 2006 |
| Range | 60 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 14.75325627 |
|---|---|
| Coefficient of variation (CV) | 0.00747445503 |
| Kurtosis | -0.6061396532 |
| Mean | 1973.823671 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.3133560081 |
| Sum | 19712577 |
| Variance | 217.6585704 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1969 | 517 | 5.2% | |
| 1970 | 509 | 5.1% | |
| 1963 | 424 | 4.2% | |
| 1968 | 391 | 3.9% | |
| 1967 | 360 | 3.6% | |
| 1966 | 333 | 3.3% | |
| 1965 | 328 | 3.3% | |
| 1964 | 324 | 3.2% | |
| 1971 | 307 | 3.1% | |
| 1979 | 265 | 2.7% | |
| Other values (51) | 6229 | 62.4% |
| Value | Count | Frequency (%) | |
| 1946 | 142 | 1.4% | |
| 1947 | 99 | 1.0% | |
| 1948 | 139 | 1.4% | |
| 1949 | 114 | 1.1% | |
| 1950 | 102 | 1.0% |
| Value | Count | Frequency (%) | |
| 2006 | 2 | < 0.1% | |
| 2005 | 65 | 0.7% | |
| 2004 | 66 | 0.7% | |
| 2003 | 150 | 1.5% | |
| 2002 | 152 | 1.5% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 742 |
| Value | Count | Frequency (%) | |
| 0 | 9245 | 92.6% | |
| 1 | 742 | 7.4% |
NEWS_SOURCE
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 51 |
| Missing (%) | 0.5% |
| Memory size | 78.0 KiB |
| NYT | |
|---|---|
| WSJ | 438 |
| SWB | 27 |
| FBI | 3 |
| Value | Count | Frequency (%) | |
| NYT | 9468 | 94.8% | |
| WSJ | 438 | 4.4% | |
| SWB | 27 | 0.3% | |
| FBI | 3 | < 0.1% | |
| (Missing) | 51 | 0.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
CODE_YEAR
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 2010 | |
|---|---|
| 2012 | |
| 2011 | |
| 2009 |
| Value | Count | Frequency (%) | |
| 2010 | 3439 | 34.4% | |
| 2012 | 3106 | 31.1% | |
| 2011 | 2191 | 21.9% | |
| 2009 | 1251 | 12.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
CODE_MONTH
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.43196155 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.607113467 |
|---|---|
| Coefficient of variation (CV) | 0.5608107945 |
| Kurtosis | -1.265804252 |
| Mean | 6.43196155 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.1014555826 |
| Sum | 64236 |
| Variance | 13.01126756 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 12 | 1151 | 11.5% | |
| 6 | 1145 | 11.5% | |
| 2 | 1128 | 11.3% | |
| 4 | 930 | 9.3% | |
| 11 | 866 | 8.7% | |
| 1 | 863 | 8.6% | |
| 5 | 721 | 7.2% | |
| 7 | 720 | 7.2% | |
| 10 | 711 | 7.1% | |
| 8 | 644 | 6.4% | |
| Other values (2) | 1108 | 11.1% |
| Value | Count | Frequency (%) | |
| 1 | 863 | 8.6% | |
| 2 | 1128 | 11.3% | |
| 3 | 615 | 6.2% | |
| 4 | 930 | 9.3% | |
| 5 | 721 | 7.2% |
| Value | Count | Frequency (%) | |
| 12 | 1151 | 11.5% | |
| 11 | 866 | 8.7% | |
| 10 | 711 | 7.1% | |
| 9 | 493 | 4.9% | |
| 8 | 644 | 6.4% |
CODE_DAY
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.66386302 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 15 |
| Q3 | 24 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 9.084944112 |
|---|---|
| Coefficient of variation (CV) | 0.5799938431 |
| Kurtosis | -1.259435152 |
| Mean | 15.66386302 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.04824035887 |
| Sum | 156435 |
| Variance | 82.53620951 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 9 | 455 | 4.6% | |
| 30 | 405 | 4.1% | |
| 6 | 381 | 3.8% | |
| 3 | 374 | 3.7% | |
| 20 | 357 | 3.6% | |
| 2 | 352 | 3.5% | |
| 25 | 351 | 3.5% | |
| 4 | 350 | 3.5% | |
| 1 | 344 | 3.4% | |
| 27 | 344 | 3.4% | |
| Other values (21) | 6274 | 62.8% |
| Value | Count | Frequency (%) | |
| 1 | 344 | 3.4% | |
| 2 | 352 | 3.5% | |
| 3 | 374 | 3.7% | |
| 4 | 350 | 3.5% | |
| 5 | 313 | 3.1% |
| Value | Count | Frequency (%) | |
| 31 | 232 | 2.3% | |
| 30 | 405 | 4.1% | |
| 29 | 321 | 3.2% | |
| 28 | 313 | 3.1% | |
| 27 | 344 | 3.4% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 1 | |
|---|---|
| 0 | 717 |
| Value | Count | Frequency (%) | |
| 1 | 9270 | 92.8% | |
| 0 | 717 | 7.2% |
posthoc
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 844 |
| Value | Count | Frequency (%) | |
| 0 | 9143 | 91.5% | |
| 1 | 844 | 8.5% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 131 |
| Missing (%) | 1.3% |
| Memory size | 78.0 KiB |
| 1 | |
|---|---|
| 2 | |
| 4 | |
| 5 | 8 |
| Value | Count | Frequency (%) | |
| 1 | 5285 | 52.9% | |
| 2 | 3146 | 31.5% | |
| 4 | 1417 | 14.2% | |
| 5 | 8 | 0.1% | |
| (Missing) | 131 | 1.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
linked
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 5921 | 59.3% | |
| 1 | 4066 | 40.7% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 308 |
| Missing (%) | 3.1% |
| Memory size | 78.0 KiB |
| 3 | |
|---|---|
| 1 | 692 |
| 2 | 5 |
| Value | Count | Frequency (%) | |
| 3 | 8982 | 89.9% | |
| 1 | 692 | 6.9% | |
| 2 | 5 | 0.1% | |
| (Missing) | 308 | 3.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
GP3
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| UNITED STATES | |
|---|---|
| united states | |
| United States | 338 |
| undefined | 107 |
| Value | Count | Frequency (%) | |
| UNITED STATES | 7786 | 78.0% | |
| united states | 1756 | 17.6% | |
| United States | 338 | 3.4% | |
| undefined | 107 | 1.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.95714429 |
| Min length | 9 |
| Distinct | 1296 |
|---|---|
| Distinct (%) | 13.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 78.0 KiB |
| UNITED STATES | |
|---|---|
| NEW YORK | |
| New York | 323 |
| WASHINGTON | 321 |
| CHICAGO | 229 |
| Other values (1291) |
| Value | Count | Frequency (%) | |
| UNITED STATES | 1129 | 11.3% | |
| NEW YORK | 942 | 9.4% | |
| New York | 323 | 3.2% | |
| WASHINGTON | 321 | 3.2% | |
| CHICAGO | 229 | 2.3% | |
| BIRMINGHAM | 156 | 1.6% | |
| new york | 147 | 1.5% | |
| MIAMI | 135 | 1.4% | |
| SAN FRANCISCO | 124 | 1.2% | |
| MISSISSIPPI | 108 | 1.1% | |
| Other values (1286) | 6372 | 63.8% |
Unique
| Unique | 576 ? |
|---|---|
| Unique (%) | 5.8% |
Length
| Max length | 42 |
|---|---|
| Median length | 9 |
| Mean length | 10.13127065 |
| Min length | 3 |
| Distinct | 1223 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 112 |
| Missing (%) | 1.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.28862047 |
|---|---|
| Minimum | 0 |
| Maximum | 63.0625 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 29.95459938 |
| Q1 | 36.16999817 |
| median | 39.29040146 |
| Q3 | 40.78340149 |
| 95-th percentile | 43.11809921 |
| Maximum | 63.0625 |
| Range | 63.0625 |
| Interquartile range (IQR) | 4.61340332 |
Descriptive statistics
| Standard deviation | 4.772670076 |
|---|---|
| Coefficient of variation (CV) | 0.1246498311 |
| Kurtosis | 4.361734479 |
| Mean | 38.28862047 |
| Median Absolute Deviation (MAD) | 1.55970001 |
| Skewness | -1.207873464 |
| Sum | 378100.1271 |
| Variance | 22.77837965 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 40.71429825 | 1130 | 11.3% | |
| 38 | 1129 | 11.3% | |
| 38.89509964 | 424 | 4.2% | |
| 42.14970016 | 325 | 3.3% | |
| 41.84999847 | 230 | 2.3% | |
| 33.52069855 | 167 | 1.7% | |
| 25.77429962 | 156 | 1.6% | |
| 40.65010071 | 152 | 1.5% | |
| 37.77489853 | 126 | 1.3% | |
| 32.76729965 | 113 | 1.1% | |
| Other values (1213) | 5923 | 59.3% | |
| (Missing) | 112 | 1.1% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1.061669946 | 1 | < 0.1% | |
| 6.95306015 | 1 | < 0.1% | |
| 13 | 4 | < 0.1% | |
| 13.44439983 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 63.0625 | 3 | < 0.1% | |
| 61.89390182 | 1 | < 0.1% | |
| 61.38499832 | 1 | < 0.1% | |
| 61.2181015 | 3 | < 0.1% | |
| 60.98720169 | 4 | < 0.1% |
| Distinct | 1225 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 111 |
| Missing (%) | 1.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -85.89808498 |
|---|---|
| Minimum | -176.7839966 |
| Maximum | 158.1529999 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | -176.7839966 |
|---|---|
| 5-th percentile | -119.7460022 |
| Q1 | -94.65242767 |
| median | -81.71700287 |
| Q3 | -74.17240143 |
| 95-th percentile | -73.7562027 |
| Maximum | 158.1529999 |
| Range | 334.9369965 |
| Interquartile range (IQR) | 20.48002624 |
Descriptive statistics
| Standard deviation | 15.87729134 |
|---|---|
| Coefficient of variation (CV) | -0.1848387115 |
| Kurtosis | 34.91982343 |
| Mean | -85.89808498 |
| Median Absolute Deviation (MAD) | 7.71100617 |
| Skewness | 1.001112646 |
| Sum | -848329.4872 |
| Variance | 252.0883804 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -97 | 1129 | 11.3% | |
| -74.0059967 | 1107 | 11.1% | |
| -77.03639984 | 425 | 4.3% | |
| -74.93840027 | 325 | 3.3% | |
| -87.65010071 | 230 | 2.3% | |
| -86.80249786 | 167 | 1.7% | |
| -80.1937027 | 156 | 1.6% | |
| -73.94960022 | 152 | 1.5% | |
| -122.4189987 | 126 | 1.3% | |
| -89.68119812 | 114 | 1.1% | |
| Other values (1215) | 5945 | 59.5% | |
| (Missing) | 111 | 1.1% |
| Value | Count | Frequency (%) | |
| -176.7839966 | 3 | < 0.1% | |
| -169.5339966 | 1 | < 0.1% | |
| -158.8890076 | 1 | < 0.1% | |
| -157.8580017 | 13 | 0.1% | |
| -157.822998 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 158.1529999 | 1 | < 0.1% | |
| 154.8009949 | 1 | < 0.1% | |
| 144.7369995 | 1 | < 0.1% | |
| 144 | 4 | < 0.1% | |
| 0 | 1 | < 0.1% |
LOC_TYPE
Real number (ℝ≥0)
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 28 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.84456271 |
|---|---|
| Minimum | 0 |
| Maximum | 28 |
| Zeros | 55 |
| Zeros (%) | 0.6% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 10 |
| Q3 | 21 |
| 95-th percentile | 27 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 9.538736067 |
|---|---|
| Coefficient of variation (CV) | 0.8053261486 |
| Kurtosis | -1.506736706 |
| Mean | 11.84456271 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.2457110497 |
| Sum | 117960 |
| Variance | 90.98748575 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 3886 | 38.9% | |
| 21 | 1151 | 11.5% | |
| 27 | 1097 | 11.0% | |
| 18 | 923 | 9.2% | |
| 9 | 356 | 3.6% | |
| 4 | 309 | 3.1% | |
| 15 | 251 | 2.5% | |
| 14 | 246 | 2.5% | |
| 16 | 236 | 2.4% | |
| 19 | 197 | 2.0% | |
| Other values (19) | 1307 | 13.1% |
| Value | Count | Frequency (%) | |
| 0 | 55 | 0.6% | |
| 1 | 46 | 0.5% | |
| 2 | 3886 | 38.9% | |
| 3 | 14 | 0.1% | |
| 4 | 309 | 3.1% |
| Value | Count | Frequency (%) | |
| 28 | 132 | 1.3% | |
| 27 | 1097 | 11.0% | |
| 26 | 14 | 0.1% | |
| 25 | 26 | 0.3% | |
| 24 | 70 | 0.7% |
AD_VIOL
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 78 |
| Value | Count | Frequency (%) | |
| 0 | 9909 | 99.2% | |
| 1 | 78 | 0.8% |
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 4690 |
| Missing (%) | 47.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.68283934 |
|---|---|
| Minimum | 1 |
| Maximum | 18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 17 |
| median | 17 |
| Q3 | 17 |
| 95-th percentile | 17 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.884864289 |
|---|---|
| Coefficient of variation (CV) | 0.1129822238 |
| Kurtosis | 36.29515004 |
| Mean | 16.68283934 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -6.042899082 |
| Sum | 88369 |
| Variance | 3.552713387 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 17 | 5086 | 50.9% | |
| 5 | 34 | 0.3% | |
| 18 | 32 | 0.3% | |
| 4 | 28 | 0.3% | |
| 7 | 21 | 0.2% | |
| 9 | 16 | 0.2% | |
| 15 | 15 | 0.2% | |
| 2 | 10 | 0.1% | |
| 8 | 10 | 0.1% | |
| 11 | 10 | 0.1% | |
| Other values (7) | 35 | 0.4% | |
| (Missing) | 4690 | 47.0% |
| Value | Count | Frequency (%) | |
| 1 | 5 | 0.1% | |
| 2 | 10 | 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 28 | 0.3% | |
| 5 | 34 | 0.3% |
| Value | Count | Frequency (%) | |
| 18 | 32 | 0.3% | |
| 17 | 5086 | 50.9% | |
| 16 | 9 | 0.1% | |
| 15 | 15 | 0.2% | |
| 14 | 2 | < 0.1% |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 4705 |
| Missing (%) | 47.1% |
| Memory size | 78.0 KiB |
| 4 | |
|---|---|
| 1 | |
| 2 | |
| 3 | 74 |
| Value | Count | Frequency (%) | |
| 4 | 2638 | 26.4% | |
| 1 | 1562 | 15.6% | |
| 2 | 1008 | 10.1% | |
| 3 | 74 | 0.7% | |
| (Missing) | 4705 | 47.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 6525 |
| Missing (%) | 65.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.131426921 |
|---|---|
| Minimum | 1 |
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 6 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.084407846 |
|---|---|
| Coefficient of variation (CV) | 0.4062043322 |
| Kurtosis | -0.06651003921 |
| Mean | 5.131426921 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.256601584 |
| Sum | 17765 |
| Variance | 4.344756068 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 2007 | 20.1% | |
| 7 | 624 | 6.2% | |
| 1 | 591 | 5.9% | |
| 4 | 100 | 1.0% | |
| 2 | 90 | 0.9% | |
| 3 | 41 | 0.4% | |
| 5 | 5 | 0.1% | |
| 9 | 4 | < 0.1% | |
| (Missing) | 6525 | 65.3% |
| Value | Count | Frequency (%) | |
| 1 | 591 | 5.9% | |
| 2 | 90 | 0.9% | |
| 3 | 41 | 0.4% | |
| 4 | 100 | 1.0% | |
| 5 | 5 | 0.1% |
| Value | Count | Frequency (%) | |
| 9 | 4 | < 0.1% | |
| 7 | 624 | 6.2% | |
| 6 | 2007 | 20.1% | |
| 5 | 5 | 0.1% | |
| 4 | 100 | 1.0% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 8619 |
| Missing (%) | 86.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.887426901 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.230751949 |
|---|---|
| Coefficient of variation (CV) | 0.426245232 |
| Kurtosis | -1.015460965 |
| Mean | 2.887426901 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.02407103256 |
| Sum | 3950 |
| Variance | 1.51475036 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 345 | 3.5% | |
| 4 | 338 | 3.4% | |
| 2 | 330 | 3.3% | |
| 1 | 218 | 2.2% | |
| 5 | 137 | 1.4% | |
| (Missing) | 8619 | 86.3% |
| Value | Count | Frequency (%) | |
| 1 | 218 | 2.2% | |
| 2 | 330 | 3.3% | |
| 3 | 345 | 3.5% | |
| 4 | 338 | 3.4% | |
| 5 | 137 | 1.4% |
| Value | Count | Frequency (%) | |
| 5 | 137 | 1.4% | |
| 4 | 338 | 3.4% | |
| 3 | 345 | 3.5% | |
| 2 | 330 | 3.3% | |
| 1 | 218 | 2.2% |
| Distinct | 35 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 8631 |
| Missing (%) | 86.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.1320059 |
|---|---|
| Minimum | 1 |
| Maximum | 42 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 18 |
| median | 25.5 |
| Q3 | 33 |
| 95-th percentile | 41 |
| Maximum | 42 |
| Range | 41 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.07063437 |
|---|---|
| Coefficient of variation (CV) | 0.4236427319 |
| Kurtosis | -0.5449379791 |
| Mean | 26.1320059 |
| Median Absolute Deviation (MAD) | 7.5 |
| Skewness | -0.2926678179 |
| Sum | 35435 |
| Variance | 122.5589453 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 41 | 306 | 3.1% | |
| 22 | 205 | 2.1% | |
| 30 | 162 | 1.6% | |
| 17 | 131 | 1.3% | |
| 28 | 75 | 0.8% | |
| 24 | 64 | 0.6% | |
| 23 | 55 | 0.6% | |
| 32 | 50 | 0.5% | |
| 4 | 47 | 0.5% | |
| 6 | 27 | 0.3% | |
| Other values (25) | 234 | 2.3% | |
| (Missing) | 8631 | 86.4% |
| Value | Count | Frequency (%) | |
| 1 | 24 | 0.2% | |
| 2 | 1 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| 4 | 47 | 0.5% | |
| 5 | 20 | 0.2% |
| Value | Count | Frequency (%) | |
| 42 | 11 | 0.1% | |
| 41 | 306 | 3.1% | |
| 40 | 2 | < 0.1% | |
| 39 | 2 | < 0.1% | |
| 38 | 1 | < 0.1% |
| Distinct | 422 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 3544 |
| Missing (%) | 35.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3149.480677 |
|---|---|
| Minimum | 1 |
| Maximum | 700000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 19 |
| Q3 | 500 |
| 95-th percentile | 6000 |
| Maximum | 700000 |
| Range | 699999 |
| Interquartile range (IQR) | 497 |
Descriptive statistics
| Standard deviation | 26027.7169 |
|---|---|
| Coefficient of variation (CV) | 8.264129733 |
| Kurtosis | 306.9358213 |
| Mean | 3149.480677 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 16.05290657 |
| Sum | 20292104 |
| Variance | 677442047.2 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 1396 | 14.0% | |
| 3 | 586 | 5.9% | |
| 15 | 520 | 5.2% | |
| 60 | 486 | 4.9% | |
| 1500 | 409 | 4.1% | |
| 2500 | 238 | 2.4% | |
| 2 | 214 | 2.1% | |
| 6000 | 148 | 1.5% | |
| 4 | 110 | 1.1% | |
| 200 | 94 | 0.9% | |
| Other values (412) | 2242 | 22.4% | |
| (Missing) | 3544 | 35.5% |
| Value | Count | Frequency (%) | |
| 1 | 1396 | 14.0% | |
| 2 | 214 | 2.1% | |
| 3 | 586 | 5.9% | |
| 4 | 110 | 1.1% | |
| 5 | 64 | 0.6% |
| Value | Count | Frequency (%) | |
| 700000 | 1 | < 0.1% | |
| 650000 | 1 | < 0.1% | |
| 525000 | 1 | < 0.1% | |
| 505000 | 1 | < 0.1% | |
| 500000 | 2 | < 0.1% |
| Distinct | 422 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 1169 |
| Missing (%) | 11.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2766.247222 |
|---|---|
| Minimum | 1 |
| Maximum | 700000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 15 |
| Q3 | 450 |
| 95-th percentile | 6000 |
| Maximum | 700000 |
| Range | 699999 |
| Interquartile range (IQR) | 449 |
Descriptive statistics
| Standard deviation | 23327.82389 |
|---|---|
| Coefficient of variation (CV) | 8.433022077 |
| Kurtosis | 353.9305834 |
| Mean | 2766.247222 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 16.97308995 |
| Sum | 24392768 |
| Variance | 544187367.4 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 2337 | 23.4% | |
| 5 | 658 | 6.6% | |
| 3 | 605 | 6.1% | |
| 15 | 520 | 5.2% | |
| 60 | 486 | 4.9% | |
| 1500 | 413 | 4.1% | |
| 1250 | 251 | 2.5% | |
| 2500 | 237 | 2.4% | |
| 2 | 215 | 2.2% | |
| 3000 | 193 | 1.9% | |
| Other values (412) | 2903 | 29.1% | |
| (Missing) | 1169 | 11.7% |
| Value | Count | Frequency (%) | |
| 1 | 2337 | 23.4% | |
| 2 | 215 | 2.2% | |
| 3 | 605 | 6.1% | |
| 4 | 110 | 1.1% | |
| 5 | 658 | 6.6% |
| Value | Count | Frequency (%) | |
| 700000 | 1 | < 0.1% | |
| 650000 | 1 | < 0.1% | |
| 525000 | 1 | < 0.1% | |
| 505000 | 1 | < 0.1% | |
| 500000 | 2 | < 0.1% |
WEAP_GRD
Real number (ℝ≥0)
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 80 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.512264056 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9805940546 |
|---|---|
| Coefficient of variation (CV) | 0.6484277999 |
| Kurtosis | 1.709314735 |
| Mean | 1.512264056 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.746410401 |
| Sum | 14982 |
| Variance | 0.9615646999 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 7409 | 74.2% | |
| 3 | 864 | 8.7% | |
| 2 | 808 | 8.1% | |
| 4 | 765 | 7.7% | |
| 5 | 61 | 0.6% | |
| (Missing) | 80 | 0.8% |
| Value | Count | Frequency (%) | |
| 1 | 7409 | 74.2% | |
| 2 | 808 | 8.1% | |
| 3 | 864 | 8.7% | |
| 4 | 765 | 7.7% | |
| 5 | 61 | 0.6% |
| Value | Count | Frequency (%) | |
| 5 | 61 | 0.6% | |
| 4 | 765 | 7.7% | |
| 3 | 864 | 8.7% | |
| 2 | 808 | 8.1% | |
| 1 | 7409 | 74.2% |
| Distinct | 89 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 12 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.553102757 |
|---|---|
| Minimum | 0 |
| Maximum | 3533 |
| Zeros | 8903 |
| Zeros (%) | 89.1% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 3533 |
| Range | 3533 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 64.68078816 |
|---|---|
| Coefficient of variation (CV) | 18.20402971 |
| Kurtosis | 1793.981687 |
| Mean | 3.553102757 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 39.44361892 |
| Sum | 35442.2 |
| Variance | 4183.604357 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 8903 | 89.1% | |
| 1 | 513 | 5.1% | |
| 2 | 127 | 1.3% | |
| 0.2 | 66 | 0.7% | |
| 4 | 54 | 0.5% | |
| 3 | 53 | 0.5% | |
| 6 | 33 | 0.3% | |
| 168 | 30 | 0.3% | |
| 5 | 20 | 0.2% | |
| 320 | 15 | 0.2% | |
| Other values (79) | 161 | 1.6% |
| Value | Count | Frequency (%) | |
| 0 | 8903 | 89.1% | |
| 0.2 | 66 | 0.7% | |
| 1 | 513 | 5.1% | |
| 2 | 127 | 1.3% | |
| 3 | 53 | 0.5% |
| Value | Count | Frequency (%) | |
| 3533 | 1 | < 0.1% | |
| 3017 | 1 | < 0.1% | |
| 2600 | 1 | < 0.1% | |
| 2079 | 1 | < 0.1% | |
| 1632 | 1 | < 0.1% |
| Distinct | 100 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.375388004 |
|---|---|
| Minimum | 0 |
| Maximum | 7500 |
| Zeros | 8903 |
| Zeros (%) | 89.1% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 7500 |
| Range | 7500 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 120.4981797 |
|---|---|
| Coefficient of variation (CV) | 18.90052489 |
| Kurtosis | 1905.201967 |
| Mean | 6.375388004 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 38.64096993 |
| Sum | 63671 |
| Variance | 14519.8113 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 8903 | 89.1% | |
| 1 | 544 | 5.4% | |
| 2 | 119 | 1.2% | |
| 4 | 75 | 0.8% | |
| 3 | 55 | 0.6% | |
| 6 | 38 | 0.4% | |
| 168 | 30 | 0.3% | |
| 5 | 22 | 0.2% | |
| 320 | 15 | 0.2% | |
| 11 | 11 | 0.1% | |
| Other values (90) | 175 | 1.8% |
| Value | Count | Frequency (%) | |
| 0 | 8903 | 89.1% | |
| 1 | 544 | 5.4% | |
| 2 | 119 | 1.2% | |
| 3 | 55 | 0.6% | |
| 4 | 75 | 0.8% |
| Value | Count | Frequency (%) | |
| 7500 | 1 | < 0.1% | |
| 4500 | 1 | < 0.1% | |
| 3533 | 1 | < 0.1% | |
| 3150 | 1 | < 0.1% | |
| 3017 | 1 | < 0.1% |
E_LENGTH
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 1 | |
|---|---|
| 4 | |
| 2 | 577 |
| 3 | 426 |
| Value | Count | Frequency (%) | |
| 1 | 8144 | 81.5% | |
| 4 | 840 | 8.4% | |
| 2 | 577 | 5.8% | |
| 3 | 426 | 4.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3762891759 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 9245 |
| Zeros (%) | 92.6% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.69097418 |
|---|---|
| Coefficient of variation (CV) | 4.493815631 |
| Kurtosis | 24.58089522 |
| Mean | 0.3762891759 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.020115879 |
| Sum | 3758 |
| Variance | 2.859393679 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 9245 | 92.6% | |
| 10 | 237 | 2.4% | |
| 1 | 217 | 2.2% | |
| 3 | 78 | 0.8% | |
| 2 | 78 | 0.8% | |
| 4 | 36 | 0.4% | |
| 5 | 34 | 0.3% | |
| 9 | 21 | 0.2% | |
| 6 | 18 | 0.2% | |
| 7 | 14 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 9245 | 92.6% | |
| 1 | 217 | 2.2% | |
| 2 | 78 | 0.8% | |
| 3 | 78 | 0.8% | |
| 4 | 36 | 0.4% |
| Value | Count | Frequency (%) | |
| 10 | 237 | 2.4% | |
| 9 | 21 | 0.2% | |
| 8 | 9 | 0.1% | |
| 7 | 14 | 0.1% | |
| 6 | 18 | 0.2% |
DAM_PROP
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 167 |
| Value | Count | Frequency (%) | |
| 0 | 9820 | 98.3% | |
| 1 | 167 | 1.7% |
arrests
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 391 |
| Value | Count | Frequency (%) | |
| 0 | 9596 | 96.1% | |
| 1 | 391 | 3.9% |
PER_ATK_I
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 7266 | 72.8% | |
| 1 | 2721 | 27.2% |
PER_ATK_E
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 276 |
| Value | Count | Frequency (%) | |
| 0 | 9711 | 97.2% | |
| 1 | 276 | 2.8% |
PUB_ORDER
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 433 |
| Value | Count | Frequency (%) | |
| 0 | 9554 | 95.7% | |
| 1 | 433 | 4.3% |
retribution
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 293 |
| Value | Count | Frequency (%) | |
| 0 | 9694 | 97.1% | |
| 1 | 293 | 2.9% |
AMBIG_WGT
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 0.5 | 137 |
| Value | Count | Frequency (%) | |
| 0 | 9850 | 98.6% | |
| 0.5 | 137 | 1.4% |
SC_ANIMOSITY
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 6095 | 61.0% | |
| 1 | 3892 | 39.0% |
ANTI_GOV_SENTMNTS
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 6440 | 64.5% | |
| 1 | 3547 | 35.5% |
CLASS_CONFLICT
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 8015 | 80.3% | |
| 1 | 1972 | 19.7% |
POL_DESIRES
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 8985 | 90.0% | |
| 1 | 1002 | 10.0% |
RETAIN_POWER
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 515 |
| Value | Count | Frequency (%) | |
| 0 | 9472 | 94.8% | |
| 1 | 515 | 5.2% |
ECO_SCARCITY
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 96 |
| Value | Count | Frequency (%) | |
| 0 | 9891 | 99.0% | |
| 1 | 96 | 1.0% |
PERS_SECURITY
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 259 |
| Value | Count | Frequency (%) | |
| 0 | 9728 | 97.4% | |
| 1 | 259 | 2.6% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.0 KiB |
| 0 | |
|---|---|
| 1 | 742 |
| Value | Count | Frequency (%) | |
| 0 | 9245 | 92.6% | |
| 1 | 742 | 7.4% |
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 3151 |
| Missing (%) | 31.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.669543593 |
|---|---|
| Minimum | 1 |
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 8 |
| Q3 | 12 |
| 95-th percentile | 13 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 5.259032693 |
|---|---|
| Coefficient of variation (CV) | 0.7885146292 |
| Kurtosis | -1.832477082 |
| Mean | 6.669543593 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.04047278294 |
| Sum | 45593 |
| Variance | 27.65742487 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 2557 | 25.6% | |
| 13 | 1446 | 14.5% | |
| 12 | 1077 | 10.8% | |
| 10 | 546 | 5.5% | |
| 2 | 366 | 3.7% | |
| 4 | 344 | 3.4% | |
| 8 | 317 | 3.2% | |
| 9 | 84 | 0.8% | |
| 3 | 43 | 0.4% | |
| 5 | 42 | 0.4% | |
| Other values (3) | 14 | 0.1% | |
| (Missing) | 3151 | 31.6% |
| Value | Count | Frequency (%) | |
| 1 | 2557 | 25.6% | |
| 2 | 366 | 3.7% | |
| 3 | 43 | 0.4% | |
| 4 | 344 | 3.4% | |
| 5 | 42 | 0.4% |
| Value | Count | Frequency (%) | |
| 13 | 1446 | 14.5% | |
| 12 | 1077 | 10.8% | |
| 11 | 5 | 0.1% | |
| 10 | 546 | 5.5% | |
| 9 | 84 | 0.8% |
weapon
Real number (ℝ≥0)
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.489035746 |
|---|---|
| Minimum | 1 |
| Maximum | 27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 22.7 |
| Maximum | 27 |
| Range | 26 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 6.860864011 |
|---|---|
| Coefficient of variation (CV) | 1.528360298 |
| Kurtosis | 2.733571844 |
| Mean | 4.489035746 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.943182608 |
| Sum | 44832 |
| Variance | 47.07145498 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 7409 | 74.2% | |
| 14 | 544 | 5.4% | |
| 26 | 397 | 4.0% | |
| 18 | 336 | 3.4% | |
| 10 | 313 | 3.1% | |
| 7 | 311 | 3.1% | |
| 12 | 166 | 1.7% | |
| 3 | 121 | 1.2% | |
| 9 | 69 | 0.7% | |
| 27 | 62 | 0.6% | |
| Other values (13) | 259 | 2.6% |
| Value | Count | Frequency (%) | |
| 1 | 7409 | 74.2% | |
| 2 | 8 | 0.1% | |
| 3 | 121 | 1.2% | |
| 5 | 43 | 0.4% | |
| 7 | 311 | 3.1% |
| Value | Count | Frequency (%) | |
| 27 | 62 | 0.6% | |
| 26 | 397 | 4.0% | |
| 25 | 19 | 0.2% | |
| 23 | 22 | 0.2% | |
| 22 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| month | year | KNOW_INI | INI_TYPE | NGOV_I1 | TAR_TYPE | HUMAN_T1 | HUMAN_V1 | DATE_TYP | day | JUL_START_DATE | JUL_END_DATE | DAY_SPAN | N_INJURD | TAR_GPOL | aid | PUB_MON | PUB_DATE | PUB_YEAR | recap | NEWS_SOURCE | CODE_YEAR | CODE_MONTH | CODE_DAY | event | posthoc | EV_TYPE | linked | pinpoint | GP3 | GP4 | GP7 | GP8 | LOC_TYPE | AD_VIOL | AD_TACT | EXP_TYPE | ATK_TYPE | DSA_TYPE | STAT_ACT | N_OF_INI_P | N_OF_INI_A | WEAP_GRD | N_KILLED_P | N_KILLED_A | E_LENGTH | N_INJURD_D | DAM_PROP | arrests | PER_ATK_I | PER_ATK_E | PUB_ORDER | retribution | AMBIG_WGT | SC_ANIMOSITY | ANTI_GOV_SENTMNTS | CLASS_CONFLICT | POL_DESIRES | RETAIN_POWER | ECO_SCARCITY | PERS_SECURITY | QUASI_EVENT | victim_effect | weapon | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 36.0 | 36.0 | 4.0 | 9.0 | 369.0 | 379.0 | 11.0 | 0 | 0 | 2124804.0 | 1 | 15 | 1946 | 0 | NYT | 2010 | 9 | 16 | 1 | 0 | 1.0 | 1 | 3.0 | UNITED STATES | STAMFORD | 41.053398 | -73.538696 | 2.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 0.0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1.0 | 1 |
| 1 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 0.0 | NaN | NaN | 1.0 | 14.0 | 379.0 | 379.0 | 1.0 | 0 | 0 | 2124804.0 | 1 | 15 | 1946 | 0 | NYT | 2010 | 9 | 16 | 1 | 0 | 1.0 | 0 | 3.0 | UNITED STATES | STAMFORD | 41.053398 | -73.538696 | 24.0 | 0 | 17.0 | 2.0 | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 2 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 36.0 | 36.0 | 2.0 | 15.0 | 368.0 | 392.0 | 25.0 | 0 | 0 | 19148557.0 | 1 | 28 | 1946 | 1 | NYT | 2010 | 11 | 10 | 0 | 0 | 1.0 | 0 | 1.0 | UNITED STATES | UNITED STATES | 38.000000 | -97.000000 | 2.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | 17000.0 | 17000.0 | 1.0 | 0.0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | NaN | 1 |
| 3 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 36.0 | 36.0 | 4.0 | 16.0 | 376.0 | 385.0 | 10.0 | 0 | 0 | 19150677.0 | 1 | 21 | 1946 | 0 | NYT | 2010 | 12 | 18 | 1 | 0 | 1.0 | 1 | 3.0 | UNITED STATES | LACKAWANNA | 42.825600 | -78.823402 | 13.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | 11000.0 | 11000.0 | 1.0 | 0.0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 4 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 36.0 | 36.0 | 4.0 | 20.0 | 385.0 | 385.0 | 1.0 | 0 | 0 | 19150677.0 | 1 | 21 | 1946 | 0 | NYT | 2010 | 12 | 18 | 1 | 0 | 1.0 | 0 | 3.0 | UNITED STATES | LACKAWANNA | 42.825600 | -78.823402 | 13.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | 2500.0 | 2500.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 5 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 38.0 | NaN | 1.0 | 25.0 | 390.0 | 390.0 | 1.0 | 0 | 0 | 19149205.0 | 1 | 26 | 1946 | 0 | NYT | 2011 | 1 | 3 | 1 | 0 | 1.0 | 0 | 3.0 | united states | Joliet | 41.525002 | -88.081703 | 14.0 | 0 | 17.0 | 2.0 | NaN | NaN | NaN | 60.0 | 60.0 | 1.0 | 0.0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1.0 | 1 |
| 6 | 1.0 | 1946 | 1.0 | 2.0 | NaN | 2.0 | NaN | NaN | 1.0 | 25.0 | 390.0 | 390.0 | 1.0 | 0 | 0 | 19149205.0 | 1 | 26 | 1946 | 0 | NYT | 2011 | 1 | 3 | 1 | 0 | 4.0 | 0 | 3.0 | UNITED STATES | CHICAGO | 41.849998 | -87.650101 | 14.0 | 0 | NaN | NaN | NaN | 3.0 | 33.0 | NaN | NaN | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 7 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 37.0 | 37.0 | 2.0 | 16.0 | 379.0 | 383.0 | 5.0 | 0 | 0 | 19150356.0 | 1 | 22 | 1946 | 0 | NYT | 2011 | 5 | 26 | 1 | 0 | 1.0 | 1 | 3.0 | united states | Flint | 43.012501 | -83.687500 | 18.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 0.0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1.0 | 1 |
| 8 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 36.0 | 36.0 | 4.0 | 10.0 | 372.0 | 378.0 | 7.0 | 0 | 0 | 19152099.0 | 1 | 14 | 1946 | 0 | NYT | 2012 | 2 | 16 | 1 | 0 | 1.0 | 0 | 3.0 | UNITED STATES | NEW YORK | 42.149700 | -74.938400 | 2.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | 7000.0 | 7000.0 | 1.0 | 0.0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 13.0 | 1 |
| 9 | 1.0 | 1946 | 1.0 | 1.0 | 6.0 | 1.0 | 36.0 | 36.0 | 1.0 | 17.0 | 382.0 | 382.0 | 1.0 | 0 | 0 | 19205021.0 | 6 | 27 | 1946 | 0 | NYT | 2012 | 2 | 20 | 1 | 0 | 1.0 | 1 | 3.0 | UNITED STATES | LOS ANGELES | 34.052200 | -118.244003 | 14.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | 2500.0 | 2500.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 4.0 | 1 |
Last rows
| month | year | KNOW_INI | INI_TYPE | NGOV_I1 | TAR_TYPE | HUMAN_T1 | HUMAN_V1 | DATE_TYP | day | JUL_START_DATE | JUL_END_DATE | DAY_SPAN | N_INJURD | TAR_GPOL | aid | PUB_MON | PUB_DATE | PUB_YEAR | recap | NEWS_SOURCE | CODE_YEAR | CODE_MONTH | CODE_DAY | event | posthoc | EV_TYPE | linked | pinpoint | GP3 | GP4 | GP7 | GP8 | LOC_TYPE | AD_VIOL | AD_TACT | EXP_TYPE | ATK_TYPE | DSA_TYPE | STAT_ACT | N_OF_INI_P | N_OF_INI_A | WEAP_GRD | N_KILLED_P | N_KILLED_A | E_LENGTH | N_INJURD_D | DAM_PROP | arrests | PER_ATK_I | PER_ATK_E | PUB_ORDER | retribution | AMBIG_WGT | SC_ANIMOSITY | ANTI_GOV_SENTMNTS | CLASS_CONFLICT | POL_DESIRES | RETAIN_POWER | ECO_SCARCITY | PERS_SECURITY | QUASI_EVENT | victim_effect | weapon | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9977 | 8.0 | 2005 | 1.0 | 1.0 | 2.0 | 1.0 | 37.0 | 37.0 | 1.0 | 10.0 | 22138.0 | 22138.0 | 1.0 | 0 | 0 | 24058412.0 | 8 | 12 | 2005 | 0 | NYT | 2010 | 6 | 7 | 1 | 0 | 1.0 | 1 | 1.0 | UNITED STATES | UNITED STATES | 38.000000 | -97.000000 | 27.0 | 0 | 17.0 | 1.0 | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 9978 | 8.0 | 2005 | 1.0 | 2.0 | NaN | 3.0 | NaN | NaN | 3.0 | 16.0 | 22129.0 | 22159.0 | 31.0 | 0 | 1 | 24061678.0 | 9 | 5 | 2005 | 0 | NYT | 2011 | 11 | 16 | 1 | 0 | 4.0 | 0 | 1.0 | UNITED STATES | NEW MEXICO | 34.837502 | -106.236999 | 2.0 | 0 | NaN | NaN | NaN | 5.0 | 6.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 9979 | 8.0 | 2005 | 1.0 | 2.0 | NaN | 3.0 | NaN | NaN | 3.0 | 16.0 | 22129.0 | 22159.0 | 31.0 | 0 | 1 | 24061678.0 | 9 | 5 | 2005 | 0 | NYT | 2011 | 11 | 16 | 1 | 0 | 4.0 | 0 | 1.0 | UNITED STATES | ARIZONA | 33.771198 | -111.388001 | 2.0 | 0 | NaN | NaN | NaN | 5.0 | 6.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 9980 | 9.0 | 2005 | 1.0 | 1.0 | 5.0 | 1.0 | 29.0 | 29.0 | 1.0 | 4.0 | 22163.0 | 22163.0 | 1.0 | 0 | 0 | 24061727.0 | 9 | 5 | 2005 | 0 | NYT | 2011 | 3 | 1 | 1 | 0 | 2.0 | 1 | 3.0 | UNITED STATES | NEW ORLEANS | 29.954599 | -90.075104 | 6.0 | 0 | NaN | NaN | 6.0 | NaN | NaN | 15.0 | 15.0 | 3.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 13.0 | 15 |
| 9981 | 9.0 | 2005 | 1.0 | 1.0 | 36.0 | 1.0 | 37.0 | 37.0 | 1.0 | 4.0 | 22163.0 | 22163.0 | 1.0 | 0 | 0 | 24061727.0 | 9 | 5 | 2005 | 0 | NYT | 2011 | 3 | 1 | 1 | 0 | 1.0 | 0 | 3.0 | UNITED STATES | NEW ORLEANS | 29.954599 | -90.075104 | 2.0 | 0 | 17.0 | 1.0 | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 9982 | 9.0 | 2005 | 1.0 | 1.0 | 6.0 | 1.0 | 37.0 | 37.0 | 1.0 | 4.0 | 22163.0 | 22163.0 | 1.0 | 0 | 0 | 24061727.0 | 9 | 5 | 2005 | 0 | NYT | 2011 | 3 | 1 | 1 | 0 | 1.0 | 1 | 3.0 | UNITED STATES | NEW ORLEANS | 29.954599 | -90.075104 | 2.0 | 0 | 17.0 | 1.0 | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 9983 | 9.0 | 2005 | 1.0 | 1.0 | 6.0 | 1.0 | 37.0 | 37.0 | 1.0 | 4.0 | 22163.0 | 22163.0 | 1.0 | 0 | 0 | 24061727.0 | 9 | 5 | 2005 | 0 | NYT | 2011 | 3 | 1 | 1 | 0 | 1.0 | 0 | 3.0 | UNITED STATES | NEW ORLEANS | 29.954599 | -90.075104 | 2.0 | 0 | 17.0 | 1.0 | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 9984 | 9.0 | 2005 | 1.0 | 1.0 | 18.0 | 1.0 | 37.0 | 37.0 | 4.0 | 7.0 | 22129.0 | 22171.0 | 43.0 | 0 | 0 | 24063330.0 | 9 | 16 | 2005 | 1 | NYT | 2011 | 5 | 28 | 0 | 0 | 1.0 | 1 | 3.0 | UNITED STATES | CRAWFORD | 42.682999 | -103.404999 | 2.0 | 0 | 17.0 | 4.0 | NaN | NaN | NaN | 2500.0 | 2500.0 | 1.0 | 0.0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 13.0 | 1 |
| 9985 | 11.0 | 2005 | 0.5 | 1.0 | 32.0 | 1.0 | 37.0 | 37.0 | 1.0 | 22.0 | 22242.0 | 22242.0 | 1.0 | 0 | 0 | 24072677.0 | 11 | 23 | 2005 | 0 | NYT | 2009 | 9 | 8 | 1 | 0 | 2.0 | 0 | 3.0 | UNITED STATES | VIRGINIA | 37.768002 | -78.205704 | 27.0 | 0 | NaN | NaN | 2.0 | NaN | NaN | NaN | NaN | 1.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 1 |
| 9986 | 12.0 | 2005 | 0.0 | NaN | NaN | 2.0 | NaN | NaN | 1.0 | 20.0 | 22270.0 | 22270.0 | 1.0 | 0 | 0 | 24076630.0 | 12 | 22 | 2005 | 0 | NYT | 2011 | 6 | 27 | 1 | 0 | 2.0 | 0 | 3.0 | UNITED STATES | CINCINNATI | 39.161999 | -84.456902 | 16.0 | 0 | NaN | NaN | 7.0 | NaN | NaN | 3.0 | 3.0 | 4.0 | 0.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 10 |